<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Formatting row and column headers and cells</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
ol.whs2 { list-style:decimal; }
p.whs3 { margin-left:80px; }
ul.whs4 { list-style:square; }
p.whs5 { margin-left:0px; font-weight:bold; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs5 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying reports\nAdding features for users\nFormatting a grid report\nFormatting row and column headers and cells");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Formatting row and column headers and cells</h1>
<p>You can format the following aspects of row and column headers and cells, 
 in a grid report:</p>
<ul type="disc" class="whs1">
	
<li class=p><p>Font type, size, effects, and color</p></li>
	
<li class=p><p>Number format</p></li>
	
<li class=p><p>Border color, thickness, style</p></li>
	
<li class=p><p>Fill color (a solid color or a gradient that blends 
 two colors) </p></li>
	
<li class=p><p>Fill effect (such as drop shadows)</p></li>
	
<li class=p><p>Text alignment (left, center, right, or justified)</p></li>
	
<li class=p><p>Text wrapping (long text can be wrapped inside the cell)</p></li>
</ul>
<h2>To format headers and cells</h2>
<ol type="1" class="whs2">
	
<li class=p><p>Run a report.</p></li>
</ol>
<ol start="2" type="1" class="whs2">
	
<li class=p><p>From the <span style="font-weight: bold;"><B>Format</B></span> 
 menu, select <span style="font-weight: bold;"><B>Advanced Formatting</B></span>. 
 The Format: Template dialog box opens.</p></li>
</ol>
<ol><ul>
<li style="list-style: disc;" type=disc class=p><p>If DHTML is 
 disabled, click <span style="font-weight: bold;"><B>Go</B></span>. The Format 
 panel opens.</p></li>
	</ul>
</ol>
<ol start="3" type="1" class="whs2">
	
<li class=p><p>From the first drop-down list at the top of the dialog 
 box, select the area of the grid to change.</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p>To select multiple 
 column and row headers to format at one time, hold <span style="font-weight: bold;"><B>CTRL</B></span> 
 and select the headers. For example, hold <span style="font-weight: bold;"><B>CTRL</B></span> 
 and click one of your column headers and two of your row headers. Only 
 selected cells can be formatted.</p></li>
	</ul>
	
<li class=p><p>From the second drop-down list at the top of the dialog 
 box, select whether to format the <span style="font-weight: bold;"><B>All</B></span>, 
 <span style="font-weight: bold;"><B>Header</B></span>, <span style="font-weight: bold;"><B>Values</B></span>, 
 <span style="font-weight: bold;"><B>Subtotal Names</B></span>, or <span style="font-weight: bold;"><B>Subtotal 
 Values </B></span>of that area of the grid.</p></li>
	
<li class=p><p>Select one of the following tabs to access formatting 
 options for your report. Click the following links for details about the 
 options on each tab:</p></li>
</ol>
<ol><ul>
<li style="list-style: disc;" type=disc class=p><p>
<a href="Format_Template_dialog_Font.htm">Font</a>: 
 Change the font and color of letters and numbers in the report, and change 
 the background by applying gradients and other effects. </p></li>
	</ul>
</ol>
<p class="whs3">To change cell background (fill) color: </p>
<ul>
<li style="list-style: square; margin-left: -20px;" type=square class=p><p class="whs3">If&nbsp;DHTML is enabled, use the <span style="font-weight: bold;"><B>Fill 
 Color</B></span> option on the <span style="font-weight: bold;"><B>Color and 
 Lines</B></span> tab.</p></li>
	
<li style="list-style: square; margin-left: -20px;" type=square class=p><p class="whs3">If DHTML is disabled, use the <span style="font-weight: bold;"><B>Fill 
 Color</B></span> drop-down list on the <span style="font-weight: bold;"><B>Font</B></span> 
 tab. </p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p>
<a href="Format_Template_dialog_Number.htm">Number</a>: 
 Specify a number format for values. For example, you can ensure that certain 
 metric values are displayed as percentages.</p></li>
		
<li style="list-style: disc;" type=disc class=p><p>
<a href="Format_Template_dialog_Alignment.htm">Alignment</a>: 
 Specify how values and text are aligned within cells on the grid report.</p></li>
		
<li style="list-style: disc;" type=disc class=p><p>
<a href="Format_Template_dialog_Color_Lines.htm">Color 
 and Lines</a>: Change the formatting of lines in your grid report, such 
 as cell borders.</p></li>
	</ul>
</ul>
<p class="whs3">To format cell borders:</p>
<ul type="square" class="whs4">
	
<li style="margin-left: -20px;" class=p><p class="whs3">If&nbsp;DHTML 
 is enabled, use the&nbsp;<span style="font-weight: bold;"><B>Borders</B></span> 
 options on the <span style="font-weight: bold;"><B>Color and Lines</B></span> 
 tab.</p></li>
	
<li style="margin-left: -20px;" class=p><p class="whs3">If 
 DHTML is disabled, use the <span style="font-weight: bold;"><B>Borders</B></span> 
 tab in the Format panel. </p></li>
</ul>
<ol start="6" type="1" class="whs2">
	
<li class=p><p>Click <span style="font-weight: bold;"><B>Apply</B></span> 
 to apply your formatting-related changes to the report.</p></li>
</ol>
<p class="whs5">&nbsp;</p>
<p class="whs5">Related topics</p>
<ul type="disc" class="whs1">
	
<li style="margin-left: -20px;" class=p><p>
<a href="Selecting_an_autostyle_for_a_report.htm">Applying 
 a set of formatting: Autostyles</a></p></li>
	
<li style="margin-left: -20px;" class=p><p>
<a href="Resize_columns_and_rows.htm">Resizing 
 columns and rows</a></p></li>
	
<li style="margin-left: -20px;" class=p><p>
<a href="Merge_lock_headers.htm">Merging 
 column and row headers</a></p></li>
	
<li style="margin-left: -20px;" class=p><p>
<a href="Lock_column_rows_and_headers.htm">Locking 
 column and row headers</a></p></li>
	
<li style="margin-left: -20px;" class=p><p>
<a href="Remove_extra_column.htm">Removing 
 the extra &quot;metrics&quot; column from a report</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
